package com.woniuxy.mapper;


import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
public interface StatisticsMapper {

    @Select("SELECT COUNT(gid) FROM auction WHERE `status`='6' AND created LIKE '%${value}%'")
    int findAuctionCount(String time);

    @Select("SELECT COUNT(gid) FROM auction WHERE `status`=3 AND valid = 1;")
    int findAuctionOnline();
}
